Helpful Information
Home
Categories
Contact us
Category: Databases
Command-line syntax for "create table"
OS=Linux
DB=Mysql
Did it once, but discarded notes, so asking someone.
Question: Command-line syntax to create table from a schema file.
Ex: $mysql -u dave -p somedb schema.tablename<cr>
I know this is wrong, but not too far off. Correct syntax appreciated.
Thanks in Advance,
Dave
$mysql -u dave -p somedb < schema.tablename<cr>
should do the job.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by chyrag:
$mysql -u dave -p somedb < schema.tablename<cr>
should do the job.[/quote]
It worked. Thanks. It's time to write it down and save this time.
Dave
privacy (GDPR)